﻿<?xml version="1.0" encoding="utf-8" ?>
<DataScripter ConnectionString="Data Source=.;Initial Catalog=TD;Integrated Security=True"
              Simulate="False" 
              OutputPath="OutputScript.SQL"
              IfRecordExists="Skip"
              XmlInterpreter="DataScripter.UI.Old.XmlEngineConfiguratorv1, DataScripter.UI.Old">
  
  <DataProducer Name="dp" Type="DataScripter.Scripting.Query.SqlServer.DataProducer, DataScripter" />
  <OutputProducer Name="op" Type="DataScripter.Scripting.Output.Sql.SqlServer.SkipIfExistsElseInsertOutputProducer, DataScripter" />
  <Db Name="Db" Type="DataScripter.Database.SqlServer.SqlServerDb, DataScripter" />
  <DatabaseStructure Name="ds" Type="DataScripter.Database.SqlServer.SqlServerDatabaseStructure, DataScripter" />
  
  <ScriptRequest Name="TermAccountActor" Where="ActorID IN (select ActorID from Actor where CustomerNumber=274042)" IfRecordExists="Skip">
    <Lookup Name="ActorID" LookupTable="Actor" LookupField="CustomerNumber"/>
  </ScriptRequest>
  <ScriptRequest Name="TermAccount" IfRecordExists="Skip">
    <FilterByForeignKey Name="TermAccountActor_TermAccount_FK" OnTable="TermAccountActor" />
  </ScriptRequest>
  <ScriptRequest Name="TermInvestment" IfRecordExists="Skip">
    <FilterByForeignKey Name="TermInvestment_TermAccount_FK" />
  </ScriptRequest>
  
</DataScripter>
